MDX designer

 

 

 

On the left hand side there is Cube explorer with five sections:

 

§  Standard dimensions (contains all available dimensions except time dimensions) with

o    hierarchies

o    levels

o    member properties

§  Time dimensions (contains time dimensions only)

§  Measures (contains measures only with one artificial group called Default that contains

all measures sorted by alphabetic order)

§  KPIs (contains KPIs if available)

§  Named Sets (contains named sets defined on server)

 

Use elements from cube explorer drag-n-drop it to the row, column or filter area to create query.

 

 

MDX designer toolbar contains:

 

	Cell Properties	Opens Cell Properties dialog.
	Execute	Executes Analysis if the Designer is in Pause mode.
	Play / Pause	Sets execution mode. In the Play mode, the Analysis is executed immediately after any change has been made (i.e. an element has been added to or removed from the axes). In the Pause mode, the Analysis is executed on the user's request by clicking button Execute in the toolbar.
	Open in New Window	Makes a copy of a current Analysis in the Designer, change it's type to Dynamic document, and opens it in a DocumentViewer.